Tabela ContractType

Definicja tabeli ContractType

Name

ContractType

Code

ContractType

Comment

Typ umowy


Lista kolumn tabeli ContractType

Name

Code

ContractTypeID

ContractTypeID

Active

Active

Code

Code

FullName

FullName

ShortName

ShortName


Kolumna ContractTypeID tabeli ContractType

Definicja kolumny ContractTypeID tabeli ContractType

Name

ContractTypeID

Code

ContractTypeID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna Active tabeli ContractType

Definicja kolumny Active tabeli ContractType

Name

Active

Code

Active

Data Type

VARCHAR2(4)

Mandatory

No

Comment

 


Kolumna Code tabeli ContractType

Definicja kolumny Code tabeli ContractType

Name

Code

Code

Code

Data Type

VARCHAR2(4)

Mandatory

No

Comment

 


Kolumna FullName tabeli ContractType

Definicja kolumny FullName tabeli ContractType

Name

FullName

Code

FullName

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna ShortName tabeli ContractType

Definicja kolumny ShortName tabeli ContractType

Name

ShortName

Code

ShortName

Data Type

VARCHAR2(50)

Mandatory

No

Comment

 


Lista kluczy tabeli ContractType

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli ContractType

Definicja klucza Identifier_1 tabeli ContractType

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment